General discussion

Locked

Custom Number Format Problem

By Spider-Man ·
I have a user who needs a custom number format formula and I can't get it to reflect everything I need. They would like all negative values in a given spreadsheet to appear with (or without) dollar signs (depending on how the number was entered) andwith (or without) decimal points (depending on how the number was entered) in black text with parenthesis around the negative value.
As an example, they have a series of numbers, dollar amounts, and FTE's (with decimal points) and they would like those values to appear as such:

($45.65)
(1.5)
(4565)

For some reason I can get part of the formula built, but then it messes up some of the other numbers or something. Can someone please help me figure this out?!?!

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Custom Number Format Problem

by Death_Charon In reply to Custom Number Format Prob ...

Hi,

An alternative is to make the changes to the format from the system level. It may work better this way.

Goto Control Panel -> Open "Regional Setting" -> You can then select the "Numbers" & "Currencies" tabs to change the setting.

Hope it helps.

Collapse -

Custom Number Format Problem

by Spider-Man In reply to Custom Number Format Prob ...

Thanks, but I'm not permitted to change such settings at work. Mmmmmm

Collapse -

Custom Number Format Problem

by Spider-Man In reply to Custom Number Format Prob ...

Point value changed by question poster.

Collapse -

Custom Number Format Problem

by Death_Charon In reply to Custom Number Format Prob ...

Hi again,

Sorry, I didn't know that you are not supposed to change the individual work stations' regional setting? I thought that since the person involved was having problem, what need to be done is to adjust to the way the PC interprets the data. I had this problem at work before and this is the way I got around the problem. :)

Collapse -

Custom Number Format Problem

by Spider-Man In reply to Custom Number Format Prob ...

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Forums