| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Number formatting
Hi,
I am need to convert numbers from my excel file to a text file where the number needs to show up as follows: ###############.## So for $401.11 the amount formula should read " 401.11" If the number is negative, it should read " -401.11" Is this doable? Thanks ZB |
|
#2
|
|||
|
|||
|
Hi ZB
i think the following gives you what you're after -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "ZB" wrote in message ... Hi, I am need to convert numbers from my excel file to a text file where the number needs to show up as follows: ###############.## So for $401.11 the amount formula should read " 401.11" If the number is negative, it should read " -401.11" Is this doable? Thanks ZB |
|
#3
|
|||
|
|||
|
Hi
i'll try that again ... use -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "ZB" wrote in message ... Hi, I am need to convert numbers from my excel file to a text file where the number needs to show up as follows: ###############.## So for $401.11 the amount formula should read " 401.11" If the number is negative, it should read " -401.11" Is this doable? Thanks ZB |
|
#4
|
|||
|
|||
|
eek .. computer's gone mad - it keeps sending stuff and i promise i'm not
doing it .... here's the formula =REPT(" ",15-LEN(A1))&TEXT(A1,"##.00") -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "ZB" wrote in message ... Hi, I am need to convert numbers from my excel file to a text file where the number needs to show up as follows: ###############.## So for $401.11 the amount formula should read " 401.11" If the number is negative, it should read " -401.11" Is this doable? Thanks ZB |
|
#5
|
|||
|
|||
|
I came up with an "if" function, but this is a million times more elegant and
a lot less likely to create errors. Thanks a lot... and have a great weekend! -ZB "JulieD" wrote: eek .. computer's gone mad - it keeps sending stuff and i promise i'm not doing it .... here's the formula =REPT(" ",15-LEN(A1))&TEXT(A1,"##.00") -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "ZB" wrote in message ... Hi, I am need to convert numbers from my excel file to a text file where the number needs to show up as follows: ###############.## So for $401.11 the amount formula should read " 401.11" If the number is negative, it should read " -401.11" Is this doable? Thanks ZB |
|
#6
|
|||
|
|||
|
you're welcome and thanks for the feedback
-- Cheers JulieD "ZB" wrote in message ... I came up with an "if" function, but this is a million times more elegant and a lot less likely to create errors. Thanks a lot... and have a great weekend! -ZB "JulieD" wrote: eek .. computer's gone mad - it keeps sending stuff and i promise i'm not doing it .... here's the formula =REPT(" ",15-LEN(A1))&TEXT(A1,"##.00") -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "ZB" wrote in message ... Hi, I am need to convert numbers from my excel file to a text file where the number needs to show up as follows: ###############.## So for $401.11 the amount formula should read " 401.11" If the number is negative, it should read " -401.11" Is this doable? Thanks ZB |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the category axis number formatting in a Pivot Ch. | Charts and Charting in Excel | |||
| How do I do conditional formatting on number formats not patterns. | Excel Discussion (Misc queries) | |||
| Number formatting | Excel Discussion (Misc queries) | |||
| Pivot Table Drill Down Number Formatting | Excel Discussion (Misc queries) | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Linear Mode
