Dear friends,
I have a problem about custom format. i have a cell contains "1" and with custom format becomes "00 01" with ###00 00.
I would like to have a cell with text "00 01" not "1".
did i express my self?
Dear friends,
I have a problem about custom format. i have a cell contains "1" and with custom format becomes "00 01" with ###00 00.
I would like to have a cell with text "00 01" not "1".
did i express my self?
You have it looking like "00 01" and you want it to look like "00 01" - I don't understand....
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
in thi sexample cell content is "1". excel shows "00 01" in the screen. what i want, i want the content of cell become "00 01" when cell format text.
TEST.jpg
i will try to explain again, i have a cell which is includes number 1. with cell format i can see it "00 01". i try to copy this number to another cell wich cell format is text. at that cell i need to have 00 01 inside..
this may be done with vba i dont know
In E4 enter 1
In F4 enter formula
=TEXT(E2,"00 00")
F4 displays 00 01 as text
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks