Software

Ask something
Discussion Locked

Custom Number Format Problem

0 helpful
5 replies

by spider-man

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?!?!

5 replies

by death_charon

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.

by death_charon

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. :)

This discussion is closed to new replies.